home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
C/C++ Users Group Library 1996 July
/
C-C++ Users Group Library July 1996.iso
/
listings
/
v_02_09
/
2n09058b
< prev
next >
Wrap
Text File
|
1991-07-30
|
348b
|
17 lines
CREATE TABLE UpdateList
(reg# INTEGER NOT NULL,
outlet# INTEGER NOT NULL,
name CHAR (20) NOT NULL,
street CHAR (20) NOT NULL,
city CHAR (10) NOT NULL,
state CHAR (2) NOT NULL,
zip CHAR (5) NOT NULL,
action CHAR (1) CHECK (action IN ("A", "D", "B", "C"))
UNIQUE (reg#, outlet#, name, street, city, state, zip,
action));